SD - Siba- Karthik - 2016-02-23 - 25033 - Spec - New UPC82 for EMEA (Lizz by 2016-03-31) #SDSupportUPCLabels

SPECIFICATIONS

25033-Spec-New UPC82 for EMEA


Purpose

Create new UPC for EMEA West ham United. This will be UPC82.lwl and will use LAB,S17

Admin Info

Purpose
 Add Lcode - LAB in the US UPC program to work with SCode- S17
Requested By
 Lizz Paxson
Spec Created By
 Siba Mohapatra
Spec Created Date
 02/23/2016
Spec QA by
 Siba Mohapatra
Objects
 ZTSD_CODES
ZRSD_UPC_LABELS
Document Status
 Completed


Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 4
2
 Documentation
 3
3
 Development/ Config
 8
4
 Unit test in DEV
 4
5
 Unit test in QUA
 4
6
 Other activity
 0

TOTAL
 23

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]


Documents

[Attach any document(s) received for the requirement(s)]



Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]


Sl.
 Change Details
 Requested By
 Requested On
 Notes if any
1
 Add New LCode- LAB in the UPC program
 Lizz Paxson
 02/23/2016
 NA




















Functional Requirement

Purpose/WHY:


Update the UPC program with below requirements:

In Scope:

[List the activities to be included in scope]

Out of Scope:

[Out of scope activities]

Solution Summary

Added new Lcode with label UPC82.lwl for LAB-S.


Test Plan

[List test scenarios/cases to be executed here]

Test ID
 Test Scenarios
 Expected Results
SD-001
 For Stock items:

Create a Production order execute in ZSD_UPCLBL T.code under UPC(stock items only).
 The condition record should be fetched from the below tables in series.

KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr
KOTK906 Sales org./Distr. Chl/Division/Customer
KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material
KOTK908 Sales org./Distr. Chl/Division/Customer/Material
KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr
KOTK909 Sales org./Distr. Chl/Division/Customer/Usage
KOTK902 Sales org./PO type


System found an entry in 901 table with customer NEC0135 and VAS mat.grp APL for the L and S codes ie., LAB and S17
SD-002
 For Stock items:

Create a Production order execute in ZSD_UPCLBL T.code under UPC(stock items only).
 The condition record should be fetched from the below tables in series.

KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr
KOTK906 Sales org./Distr. Chl/Division/Customer
KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material
KOTK908 Sales org./Distr. Chl/Division/Customer/Material
KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr
KOTK909 Sales org./Distr. Chl/Division/Customer/Usage
KOTK902 Sales org./PO type


As the entry in 901 table is deleted i.e. with customer NEC0135 and VAS mat.grp APL the entry of 906 table is considered for the L and S codes ie., LAB and S17
SD-003
 For Stock items:

Execute ZSD_UPCLBL t.code
with the below inputs.

Material,size,qty,S.org,cur,MSRP
 The condition record should be fetched from the below tables in a series.

KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr
KOTK906 Sales org./Distr. Chl/Division/Customer

KOTK907 Sales org./Distr.
Chl/Division/VAS Cu.Gr/Material
KOTK908 Sales org./Distr. Chl/Division/Customer/Material
KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr
KOTK909 Sales org./Distr. Chl/Division/Customer/Usage
KOTK902 Sales org./PO type

As the 901 table condition record has been deleted the L and S codes from 906 table should be considered to print the labels LAB and S17 with the given input quantities.

ZMRP field is not available in S17 string, so the value should not be printed.
SD-004
 For Stock items:

Create a Purchase order with some deleted materials (EA) and execute in ZSD_UPCLBL T.code under UPC(stock items only) with print components flagged.
 The condition record should be fetched from the below tables in series.

KOTK912 (Sales org./Distr. Chl/Division/Customer/Plant/VAS Mat.gr)
KOTK901 (Sales org./Distr. Chl/Division/Customer/VAS Mat.gr)
KOTK922 (Sales org./Distr. Chl/Division/Plant)

Only the undeleted material sizes should get printed in the output.
Labels should be printed from table 912, as there is an entry exist in table 912 i.e. with Sorg-2000, Dist.chnl-10, Div-00, Plant-0320, VAS mat.gr- HDW & VAS Code- LAB, S17.
SD-005
 For Stock items:

Create a Purchase order with some deleted materials (EA) and execute in ZSD_UPCLBL T.code under UPC(stock items only) without print components flagged.
 The condition record should be fetched from the below tables in series.

KOTK912 (Sales org./Distr. Chl/Division/Customer/Plant/VAS Mat.gr)
KOTK901 (Sales org./Distr. Chl/Division/Customer/VAS Mat.gr)
KOTK922 (Sales org./Distr. Chl/Division/Plant)

Only the undeleted material sizes should get printed in the output.
Labels should be printed from table 912, as there is an entry exist in table 912 i.e. with Sorg-2000, Dist.chnl-10, Div-00, Plant-0320, VAS mat.gr- HDW & VAS Code- LAB, S17.
SD-006
 For Customer Specific items:

Create MTO sales order with no L codes/Scodes and corresponding Production order and execute in ZSD_UPCLBL T.code.
 The condition record should be fetched from KOTK901 table ie., Sales org./Distr. Chl/Division/Customer/VAS Mat.gr

There is no VAS code maintained in the sales order, then the VAS codes will be picked from 901 table. which has been maintained with Sorg-1000, Distchnl- 10, Div-00, Cust- 1000018, VAS mat. grp- HDW. With LAB & S17.
SD-007
 For Customer Specific items:

Create MTO sales order with no L codes/Scodes and corresponding Production order and execute in ZSD_UPCLBL T.code.
 The condition record should be fetched from KOTK901 table ie., Sales org./Distr. Chl/Division/Customer/VAS Mat.gr

There is no VAS code maintained in the sales order and 901 table. which has been maintained with Sorg-1000, Distchnl- 10, Div-00, Cust- 1000018, VAS mat. grp- HDW. With LAB & S17.

Error should be displayed as "'No Relevant Lcode or Scode found".
SD-008
 For Customer specific labels:

Maintain manual VAS Code (LAB, S17) in Sales order.

Execute the Tcode- ZSD_UPCLBL
Input: Sales order
 Appropriate Label should be printed with the corresponding values without any error.
SD-009
 For Customer specific labels:

Don't maintain any Lcode or Scode in Sales order.

Maintaing value in KOTK901 table.
(LAB, S17)

Execute the Tcode- ZSD_UPCLBL
 VAS code will be picked from KOTK901 table and appropriate label should be printed with corresponding values.
SD-010
 For Customer specific labels:

Don't maintain any Lcode or Scode in Sales order.

KOTK901 has invalid L & S codes.

Execute the Tcode- ZSD_UPCLBL
 No L or S codes will be printed and error message will be displayed 'No Relevent L-code or S-code found'.
SD-011
 For Customer specific labels:

Maintain manual VAS Code (LAB, S17) in Sales order.

Input Sales order # , Material#, Size, qty (any).

Execute the Tcode- ZSD_UPCLBL
Input: Sales order
 Only specific material/size with associated informations should be printed.

Appropriate Label should be printed with the corresponding values without any error.
SD-012
 For Customer specific labels:

Don't maintain any Lcode or Scode in Sales order.

Input Sales order # , Material#, Size, qty (any).

Maintaing value in KOTK901 table.
(LAB, S17)

Execute the Tcode- ZSD_UPCLBL
 Only specific material/size with associated informations should be printed.

VAS code will be picked from KOTK901 table and appropriate label should be printed with corresponding values.
SD-013
 For Customer specific labels:

Don't maintain any Lcode or Scode in Sales order.

Input Sales order # , Material#, Size, qty (any).

KOTK901 has invalid L & S codes.

Execute the Tcode- ZSD_UPCLBL
 No L or S codes will be printed and error message will be displayed 'No Relevent L-code or S-code found'.
SD-014
 For Customer specific labels:

Execute ZSD_UPCLBL t.code with the below inputs.

S.org,Cust,Material,size,Qty
 The L and S codes should be fetched from the below tables in series.

KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr
KOTK906 Sales org./Distr. Chl/Division/Customer
KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material
KOTK908 Sales org./Distr. Chl/Division/Customer/Material
KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr
KOTK909 Sales org./Distr. Chl/Division/Customer/Usage
KOTK902 Sales org./PO type

The condition record in 901 table with Cust 1000018 and VAS material grp HDW is considered to print labels ie., LAB, S17 with the given input quantities.






Solution Details


The logic has been added in the program ZRSD_UPC_LABELS to get the label UPC82.lwl,for LA7-S31 for various inputs


Issues

NA